Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.clipper.visual-objects > #13363 > unrolled thread

SQL Special characters

Started byHenry Fidler <zodcomag@gmail.com>
First post2021-06-30 11:46 -0700
Last post2021-07-04 15:18 +0200
Articles 5 — 3 participants

Back to article view | Back to comp.lang.clipper.visual-objects


Contents

  SQL Special characters Henry Fidler <zodcomag@gmail.com> - 2021-06-30 11:46 -0700
    Re: SQL Special characters dlzc <dlzc1@cox.net> - 2021-07-01 09:52 -0700
    Re: SQL Special characters "Wolfgang Riedmann" <wriedmann@gmail.com> - 2021-07-02 07:08 +0200
      Re: SQL Special characters Henry Fidler <zodcomag@gmail.com> - 2021-07-03 02:04 -0700
        Re: SQL Special characters "Wolfgang Riedmann" <wriedmann@gmail.com> - 2021-07-04 15:18 +0200

#13363 — SQL Special characters

FromHenry Fidler <zodcomag@gmail.com>
Date2021-06-30 11:46 -0700
SubjectSQL Special characters
Message-ID<dd30eff7-e522-4aee-a1fc-79652b94c533n@googlegroups.com>
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

[toc] | [next] | [standalone]


#13364

Fromdlzc <dlzc1@cox.net>
Date2021-07-01 09:52 -0700
Message-ID<cd831b3c-4e36-44d2-94d2-5b2255e848b3n@googlegroups.com>
In reply to#13363
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

[toc] | [prev] | [next] | [standalone]


#13365

From"Wolfgang Riedmann" <wriedmann@gmail.com>
Date2021-07-02 07:08 +0200
Message-ID<ik7la8Fo38vU1@mid.individual.net>
In reply to#13363
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



-- 

[toc] | [prev] | [next] | [standalone]


#13366

FromHenry Fidler <zodcomag@gmail.com>
Date2021-07-03 02:04 -0700
Message-ID<539069bd-8f2d-4090-bf55-18c67638744en@googlegroups.com>
In reply to#13365
Wolfgang vielen Dank, it does save time.

Where can one see the undocumented functions?

Henry

[toc] | [prev] | [next] | [standalone]


#13368

From"Wolfgang Riedmann" <wriedmann@gmail.com>
Date2021-07-04 15:18 +0200
Message-ID<ikdqorFtv82U1@mid.individual.net>
In reply to#13366
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

-- 

[toc] | [prev] | [standalone]


Back to top | Article view | comp.lang.clipper.visual-objects


csiph-web