Pervasive SQL german Umlauts Problem

Posted by cordellcp3 on Stack Overflow See other posts from Stack Overflow or by cordellcp3
Published on 2011-03-04T07:19:42Z Indexed on 2011/03/04 7:24 UTC
Read the original article Hit count: 334

Filed under:
|
|
|

Hi there,

I'm using the Pervasive SQL - ADO.NET 3.5 DataProvider for retrieving data out of the PSQL DB and I've noticed that the german umlauts (äöüÄÖÜ etc.) are not represented correctly in the PSQLDataReader, but in the Pervasive Control Center (similar to the sql management studio) the umlauts are all correct.

Is there anything similar to the TSQL "SET LANGUAGE"-command? I havn't found something like that for Pervasive SQL.

Googling this issue wasn't successful at all, too. Although I did find some tips with a file called upper.alt or collate.cfg, but don't know how to use this files and I coudn`t find them in my installation. (I'm totally new to Pervasive...)

I hope that someone on here could help me with that.

Thanks in advance

© Stack Overflow or respective owner

Related posts about c#

Related posts about database