I am using "MySQL ODBC 8.0 Unicode Driver" from oracle.
The MySQL is collated “utf8_general_ci”
Calling oSQLSelect:FieldGetFormatted()
I do not get the european letters, for example instead of “ä”, I get “ä”.

How can I get the real characters?

Henry

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)

Dear Henry Fidler:

On Wednesday, June 30, 2021 at 11:46:28 AM UTC-7, Henry Fidler wrote:

I am using "MySQL ODBC 8.0 Unicode Driver" from oracle.
The MySQL is collated “utf8_general_ci”
Calling oSQLSelect:FieldGetFormatted()
I do not get the european letters, for example instead of “ä”, I get “ä”.

How can I get the real characters?

I know this does not help much but the contents of the file are NOT encoded as "utf8_general_ci", or your "display" means is not understanding "utf8_general_ci".

https://en.wikipedia.org/wiki/UTF-8

I submit it is stored as a 2-byte character (and you are getting both bytes), and your display means is expecting only single bytes.

David A. Smith

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)

Hi Henry,

VO does not uses Unicode.

In the VO System Library there are two functions that are not in the
help:
UTF82Ansi() and Ansi2UTF8()

FUNCTION Ansi2UTF8(cString AS STRING) AS STRING
RETURN ConvertFromCodePageToCodePage(cString, CP_ACP, CP_UTF8)

FUNCTION Utf82Ansi(cString AS STRING) AS STRING
RETURN ConvertFromCodePageToCodePage(cString, CP_UTF8, CP_ACP)

HTH

Wolfgang


Henry Fidler wrote:

I am using "MySQL ODBC 8.0 Unicode Driver" from oracle.
The MySQL is collated “utf8_general_ci”
Calling oSQLSelect:FieldGetFormatted()
I do not get the european letters, for example instead of “ä”, I
get “ä”.

How can I get the real characters?

Henry

--

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)

Wolfgang vielen Dank, it does save time.

Where can one see the undocumented functions?

Henry

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)

Hi Henry,

it does save time.

Where can one see the undocumented functions?

try to look in the System Library - maybe you find something other
useful.

Wolfgang

--

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)