468,458 Members | 1,813 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,458 developers. It's quick & easy.

[odbc] Retreiving full unicode data using Access ODBC driver.

I am building a Blog for my own person use, and I would like to be able
to use unicode characters outside the range of the ascii set. However,
when I use odbc to access table data, Access returns question marks in
the place of the character data.

Is there any way to set the default encoding of access to "UTF-8," or,
alternatively, is there an odbc connection string that I could use to
connect to my database that would specify UTF-8 as the encoding? It
would also be acceptable to use any other encoding that allowed Access
to pass all data through the connection.

Hopefully,
John "Otac0n" Gietzen

Jan 13 '06 #1
2 3246
On 12 Jan 2006 21:41:35 -0800, Sp**************@gmail.com wrote:
I am building a Blog for my own person use, and I would like to be able
to use unicode characters outside the range of the ascii set. However,
when I use odbc to access table data, Access returns question marks in
the place of the character data.

Is there any way to set the default encoding of access to "UTF-8," or,
alternatively, is there an odbc connection string that I could use to
connect to my database that would specify UTF-8 as the encoding? It
would also be acceptable to use any other encoding that allowed Access
to pass all data through the connection.

Hopefully,
John "Otac0n" Gietzen


Are you talking about a web frontend connecting to an Acess (ie JET) database, or an Access frontend
talking to an eg Oracle or SQL backend?
Jan 14 '06 #2
Web front end connecting to a Jet backend.

Thanks in Advance,
John Gietzen

Jan 17 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Joe | last post: by
13 posts views Thread by Graham | last post: by
11 posts views Thread by DJJ | last post: by
4 posts views Thread by Andreas Lauffer | last post: by
4 posts views Thread by Dave | last post: by
reply views Thread by NPC403 | last post: by
reply views Thread by kmladenovski | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.