Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.clipper.visual-objects > #13363 > unrolled thread
| Started by | Henry Fidler <zodcomag@gmail.com> |
|---|---|
| First post | 2021-06-30 11:46 -0700 |
| Last post | 2021-07-04 15:18 +0200 |
| Articles | 5 — 3 participants |
Back to article view | Back to comp.lang.clipper.visual-objects
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
| From | Henry Fidler <zodcomag@gmail.com> |
|---|---|
| Date | 2021-06-30 11:46 -0700 |
| Subject | SQL 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]
| From | dlzc <dlzc1@cox.net> |
|---|---|
| Date | 2021-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]
| From | "Wolfgang Riedmann" <wriedmann@gmail.com> |
|---|---|
| Date | 2021-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]
| From | Henry Fidler <zodcomag@gmail.com> |
|---|---|
| Date | 2021-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]
| From | "Wolfgang Riedmann" <wriedmann@gmail.com> |
|---|---|
| Date | 2021-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