Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.clipper.visual-objects > #13365
| From | "Wolfgang Riedmann" <wriedmann@gmail.com> |
|---|---|
| Newsgroups | comp.lang.clipper.visual-objects |
| Subject | Re: SQL Special characters |
| Date | 2021-07-02 07:08 +0200 |
| Message-ID | <ik7la8Fo38vU1@mid.individual.net> (permalink) |
| References | <dd30eff7-e522-4aee-a1fc-79652b94c533n@googlegroups.com> |
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 --
Back to comp.lang.clipper.visual-objects | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread
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
csiph-web