Hello people, i'm inserting an ë in my database through a sql-script. When I later on select this value, it only shows d instead of ë. Does anyone know how i can change this. I used different charactersets and also charset=none in the connection string as a connection parameter, but i don't think this is it.
After my conversion from sybase 6 to 9 I had to explicitly tell the connection which charset I wanted to use. Our db has charset cp850 and when I connect with the newly created sybase 9 db, the characterset was automatically set to cp1252(ansii). Now I put CS=cp850 in my connectionstring and everything is solved. But thanks anywayz
Your're using Sybase Anywhere and not Sybase ASE.
Why are you using cp850 and not LATIN1 (iso1), the native Win collation sequence ? Your problem is probably coming from a bad conversion between client and server