O$:4.3.1, SQL Server 2005 and Accented characters
Denis Woodbury
denis at woodmic.net
Wed May 28 10:45:18 EDT 2008
Hi,
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
450-242-0249
More information about the omnisdev-en
mailing list