O$:4.3.1, SQL Server 2005 and Accented characters

Denis Woodbury denis at woodmic.net
Wed May 28 10:45:18 EDT 2008


The mix
OSX 10.5.2
Studio 4.3.1
Actual ODBC Driver for SQL Server 2.8e
Microsoft SQL Server 09.00.3042

When I try to insert or update a record with accented characters like (à ë é
É è Ê À-12345) in it, the database is not updated depending on the form of
statement I use.

This form will not update and return the $nativeerrortext :[Actual][SQL
Server] Error converting client characters into server's character set. Some
character(s) could not be converted.

Calculate row.name as iString
Do row.$update(oldRow) Returns flag

This form works 

Do sessionObject.$newstatement('update') Returns statementObject
Calculate stmt as con('update appusr set appusr.name =@[',nam(iString),']
where appusr.appusrid = 3')
Do statementObject.$execdirect(stmt) Returns flag

Anybody else can test this or has a solution ?

denis woodbury 
denis at woodmic.net

More information about the omnisdev-en mailing list