[kristofferj]

Hello. First of all, I want to say that I am a beginner in Sybase. When that said:

In Visual Basic, I query an Adaptive Server Anywhere database with something like this:

SELECT * FROM foo

The query gives the following result (note the foreign characters, in this case swedish characters):


id description
--------------
1 TestÅ123
2 TestÖ123


So far, that is the correct result. However, this query does not result in any rows at all:

SELECT * FROM foo WHERE description = 'TestÅ123'

That is not correct. Selecting with a LIKE clause gives the correct result:

SELECT * FROM foo WHERE description LIKE '%Test%'

When I try the second SELECT in a third-party-query-application it gives the correct resultset. So, the problem is, Visual Basic querys the database incorrectly when dealing with special characters.

As said before, I am a beginner in Sybase. Any help would be appreciated.

Thanks in advance.

[richardcrossley]

Check which character set your VB application is using. Ideally you should be using the same character set as the database server. If you're not something needs to do character set conversion; either your application or the connectivity library (Open Client / ODBC).

Find out from your DBA what the is the default character set of the server. If you can, work with that character set. I think Windows uses ISO_1, but other platforms (HP UX for example) use "Roman 8" which is different.

[kristofferj]

Ok. Thanks for your reply. But how can I check which character set my Visual Basic application is using?

[richardcrossley]

Sorry for the delay but I'm away from home and the office and the hotel has just got wi-fi. The character set that VB is using is probably "iso1", however the character set being used to talk to the database server may be specified when setting up the connection. I'm assuming this can be done within the DSN or connection properties.