Rocksolid Light

Welcome to RetroBBS

mail  files  register  newsreader  groups  login

Message-ID:  

But it does move! -- Galileo Galilei

devel / comp.lang.clipper.visual-objects / SQL Special characters

SubjectAuthor
* SQL Special charactersHenry Fidler
+- Re: SQL Special charactersdlzc
`* Re: SQL Special charactersWolfgang Riedmann
 `* Re: SQL Special charactersHenry Fidler
  `- Re: SQL Special charactersWolfgang Riedmann

1
SQL Special characters

<dd30eff7-e522-4aee-a1fc-79652b94c533n@googlegroups.com>

  copy mid

https://www.rocksolidbbs.com/devel/article-flat.php?id=861&group=comp.lang.clipper.visual-objects#861

  copy link   Newsgroups: comp.lang.clipper.visual-objects
X-Received: by 2002:a05:620a:802:: with SMTP id s2mr19891186qks.38.1625078787682;
Wed, 30 Jun 2021 11:46:27 -0700 (PDT)
X-Received: by 2002:a37:9b4b:: with SMTP id d72mr23448234qke.10.1625078787502;
Wed, 30 Jun 2021 11:46:27 -0700 (PDT)
Path: i2pn2.org!i2pn.org!paganini.bofh.team!news.dns-netz.com!news.freedyn.net!newsreader4.netcologne.de!news.netcologne.de!peer03.ams1!peer.ams1.xlned.com!news.xlned.com!peer02.iad!feed-me.highwinds-media.com!news.highwinds-media.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.lang.clipper.visual-objects
Date: Wed, 30 Jun 2021 11:46:27 -0700 (PDT)
Injection-Info: google-groups.googlegroups.com; posting-host=87.102.215.94; posting-account=FsGVgwoAAAAo88J9fd3ig_ravrDh6B2l
NNTP-Posting-Host: 87.102.215.94
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <dd30eff7-e522-4aee-a1fc-79652b94c533n@googlegroups.com>
Subject: SQL Special characters
From: zodcomag@gmail.com (Henry Fidler)
Injection-Date: Wed, 30 Jun 2021 18:46:27 +0000
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
X-Received-Bytes: 1352
 by: Henry Fidler - Wed, 30 Jun 2021 18:46 UTC

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

Re: SQL Special characters

<cd831b3c-4e36-44d2-94d2-5b2255e848b3n@googlegroups.com>

  copy mid

https://www.rocksolidbbs.com/devel/article-flat.php?id=862&group=comp.lang.clipper.visual-objects#862

  copy link   Newsgroups: comp.lang.clipper.visual-objects
X-Received: by 2002:a05:622a:1444:: with SMTP id v4mr841359qtx.143.1625158332560;
Thu, 01 Jul 2021 09:52:12 -0700 (PDT)
X-Received: by 2002:a05:622a:195:: with SMTP id s21mr899721qtw.62.1625158332333;
Thu, 01 Jul 2021 09:52:12 -0700 (PDT)
Path: i2pn2.org!i2pn.org!weretis.net!feeder8.news.weretis.net!proxad.net!feeder1-2.proxad.net!209.85.160.216.MISMATCH!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.lang.clipper.visual-objects
Date: Thu, 1 Jul 2021 09:52:12 -0700 (PDT)
In-Reply-To: <dd30eff7-e522-4aee-a1fc-79652b94c533n@googlegroups.com>
Injection-Info: google-groups.googlegroups.com; posting-host=68.107.209.13; posting-account=7bF0GwoAAABMFHX6V4fON4-1F6LFJ834
NNTP-Posting-Host: 68.107.209.13
References: <dd30eff7-e522-4aee-a1fc-79652b94c533n@googlegroups.com>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <cd831b3c-4e36-44d2-94d2-5b2255e848b3n@googlegroups.com>
Subject: Re: SQL Special characters
From: dlzc1@cox.net (dlzc)
Injection-Date: Thu, 01 Jul 2021 16:52:12 +0000
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
 by: dlzc - Thu, 1 Jul 2021 16:52 UTC

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

Re: SQL Special characters

<ik7la8Fo38vU1@mid.individual.net>

  copy mid

https://www.rocksolidbbs.com/devel/article-flat.php?id=863&group=comp.lang.clipper.visual-objects#863

  copy link   Newsgroups: comp.lang.clipper.visual-objects
Path: i2pn2.org!i2pn.org!news.swapon.de!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail
From: wriedmann@gmail.com (Wolfgang Riedmann)
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>
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
 by: Wolfgang Riedmann - Fri, 2 Jul 2021 05:08 UTC

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

--

Re: SQL Special characters

<539069bd-8f2d-4090-bf55-18c67638744en@googlegroups.com>

  copy mid

https://www.rocksolidbbs.com/devel/article-flat.php?id=864&group=comp.lang.clipper.visual-objects#864

  copy link   Newsgroups: comp.lang.clipper.visual-objects
X-Received: by 2002:a05:622a:149:: with SMTP id v9mr3615770qtw.144.1625303082795; Sat, 03 Jul 2021 02:04:42 -0700 (PDT)
X-Received: by 2002:a37:6f05:: with SMTP id k5mr4031085qkc.497.1625303082650; Sat, 03 Jul 2021 02:04:42 -0700 (PDT)
Path: i2pn2.org!i2pn.org!aioe.org!feeder1.feed.usenet.farm!feed.usenet.farm!tr3.eu1.usenetexpress.com!feeder.usenetexpress.com!tr2.iad1.usenetexpress.com!border1.nntp.dca1.giganews.com!nntp.giganews.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.lang.clipper.visual-objects
Date: Sat, 3 Jul 2021 02:04:42 -0700 (PDT)
In-Reply-To: <ik7la8Fo38vU1@mid.individual.net>
Injection-Info: google-groups.googlegroups.com; posting-host=87.102.215.94; posting-account=FsGVgwoAAAAo88J9fd3ig_ravrDh6B2l
NNTP-Posting-Host: 87.102.215.94
References: <dd30eff7-e522-4aee-a1fc-79652b94c533n@googlegroups.com> <ik7la8Fo38vU1@mid.individual.net>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <539069bd-8f2d-4090-bf55-18c67638744en@googlegroups.com>
Subject: Re: SQL Special characters
From: zodcomag@gmail.com (Henry Fidler)
Injection-Date: Sat, 03 Jul 2021 09:04:42 +0000
Content-Type: text/plain; charset="UTF-8"
Lines: 4
 by: Henry Fidler - Sat, 3 Jul 2021 09:04 UTC

Wolfgang vielen Dank, it does save time.

Where can one see the undocumented functions?

Henry

Re: SQL Special characters

<ikdqorFtv82U1@mid.individual.net>

  copy mid

https://www.rocksolidbbs.com/devel/article-flat.php?id=866&group=comp.lang.clipper.visual-objects#866

  copy link   Newsgroups: comp.lang.clipper.visual-objects
Path: i2pn2.org!i2pn.org!news.swapon.de!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail
From: wriedmann@gmail.com (Wolfgang Riedmann)
Newsgroups: comp.lang.clipper.visual-objects
Subject: Re: SQL Special characters
Date: Sun, 4 Jul 2021 15:18:18 +0200
Lines: 13
Message-ID: <ikdqorFtv82U1@mid.individual.net>
References: <dd30eff7-e522-4aee-a1fc-79652b94c533n@googlegroups.com> <ik7la8Fo38vU1@mid.individual.net> <539069bd-8f2d-4090-bf55-18c67638744en@googlegroups.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=utf-8
X-Trace: individual.net OVCUjPigwS+HDN7i1X5qOAzH//Om53q05Kkt0swTO5eE+SiWk=
Cancel-Lock: sha1:hrTwY0AN6YxcKvsm7XkpR8Ai4EQ=
User-Agent: XanaNews/1.18.1.6
 by: Wolfgang Riedmann - Sun, 4 Jul 2021 13:18 UTC

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

--

1
server_pubkey.txt

rocksolid light 0.9.8
clearnet tor