X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
> Using Unicode Characters In Vba - Help, SQL Server 2012    
post Aug 16 2019, 10:35 AM

Posts: 20
Joined: 28-January 19

I have just migrated an access database to SQL and I'm having an issue that wasn't present with the access backend mde.

When trying to do select statements using strings that contain unicode characters such as the "ohm" symbol, access is converting them in this case to "O" instead of Ω.

Access displays the symbol correctly in forms and in the tables, only in the vba code is where it gets manipulated.

I have tried using :

Pass through query
adodb recordsets
odbc connections

All of them do the same thing, the pass through query returns the correct symbol but if I try to use it in a record set the symbol gets changed.

Is there any way I can store Unicode values in strings such as Ω ?

Any help would be much appreciated.


Go to the top of the page

Posts in this topic

Custom Search

RSSSearch   Top   Lo-Fi    4th July 2020 - 06:43 AM