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

[SpoonfulofTactic]

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

[polite person]

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?

[otac0n]

Web front end connecting to a Jet backend.

Thanks in Advance,
John Gietzen