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


Groups > comp.lang.clipper.visual-objects > #13365

Re: SQL Special characters

Path csiph.com!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail
From "Wolfgang Riedmann" <wriedmann@gmail.com>
Newsgroups comp.lang.clipper.visual-objects
Subject Re: SQL Special characters
Date Fri, 2 Jul 2021 07:08:23 +0200
Lines 35
Message-ID <ik7la8Fo38vU1@mid.individual.net> (permalink)
References <dd30eff7-e522-4aee-a1fc-79652b94c533n@googlegroups.com>
Mime-Version 1.0
Content-Type text/plain; charset=utf-8
Content-Transfer-Encoding 8bit
X-Trace individual.net 1Ct//DbmNx/4YcdjuZZapQ/3Ox5WQ4bMVGP80Uh+qr40chlIc=
Cancel-Lock sha1:FFPNGTGOj+UshsJLYYluMkc++pM=
User-Agent XanaNews/1.18.1.6
Xref csiph.com comp.lang.clipper.visual-objects:13365

Show key headers only | View raw


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


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