Rocksolid Light

Welcome to novaBBS (click a section below)

mail  files  register  newsreader  groups  login

Message-ID:  

On the eighth day, God created FORTRAN.

devel / comp.databases.ingres / Re: [Info-ingres] Nvarchar versus UTF-8 varchar

SubjectAuthor
* Nvarchar versus UTF-8 varcharRoy Hann
+* Re: [Info-ingres] Nvarchar versus UTF-8 varcharKarl Schendel
|`- Re: [Info-ingres] Nvarchar versus UTF-8 varcharRoy Hann
`- Re: [Info-ingres] Nvarchar versus UTF-8 varcharAdrian Williamson

1
Nvarchar versus UTF-8 varchar

<sdrl81$u7g$1@gioia.aioe.org>

  copy mid

https://www.novabbs.com/devel/article-flat.php?id=100&group=comp.databases.ingres#100

  copy link   Newsgroups: comp.databases.ingres
Path: i2pn2.org!i2pn.org!aioe.org!ow2HZ3WUoSa7bUAoHqrJ8A.user.46.165.242.75.POSTED!not-for-mail
From: specia...@processed.almost.meat (Roy Hann)
Newsgroups: comp.databases.ingres
Subject: Nvarchar versus UTF-8 varchar
Date: Wed, 28 Jul 2021 13:14:41 -0000 (UTC)
Organization: Aioe.org NNTP Server
Message-ID: <sdrl81$u7g$1@gioia.aioe.org>
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
Injection-Info: gioia.aioe.org; logging-data="30960"; posting-host="ow2HZ3WUoSa7bUAoHqrJ8A.user.gioia.aioe.org"; mail-complaints-to="abuse@aioe.org";
User-Agent: XPN/1.2.6 (Street Spirit ; Windows)
X-Notice: Filtered by postfilter v. 0.9.2
 by: Roy Hann - Wed, 28 Jul 2021 13:14 UTC

A colleague has asked a question for which I have no answer.

When II_CHARSETxx is UTF8 what is the difference between VARCHAR and
NVARCHAR?

I know NVARCHAR uses UTF-16.

Why might I use NVARCHAR if my data can be represented with VARCHAR?

Roy

Re: [Info-ingres] Nvarchar versus UTF-8 varchar

<mailman.68.1627478576.1681.info-ingres@lists.planetingres.org>

  copy mid

https://www.novabbs.com/devel/article-flat.php?id=101&group=comp.databases.ingres#101

  copy link   Newsgroups: comp.databases.ingres
Path: i2pn2.org!i2pn.org!aioe.org!feeder1.feed.usenet.farm!feed.usenet.farm!tr3.eu1.usenetexpress.com!feeder.usenetexpress.com!tr1.iad1.usenetexpress.com!border1.nntp.dca1.giganews.com!nntp.giganews.com!buffer1.nntp.dca1.giganews.com!news.giganews.com.POSTED!not-for-mail
NNTP-Posting-Date: Wed, 28 Jul 2021 08:24:02 -0500
Return-Path: <schendel@kbcomputer.com>
X-Original-To: info-ingres@lists.planetingres.org
Delivered-To: info-ingres@mort.croker.net
From: schen...@kbcomputer.com (Karl Schendel)
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: quoted-printable
Mime-Version: 1.0 (Mac OS X Mail 13.4 \(3608.120.23.2.7\))
Date: Wed, 28 Jul 2021 09:22:52 -0400
References: <sdrl81$u7g$1@gioia.aioe.org>
To: info-ingres@lists.planetingres.org
In-Reply-To: <sdrl81$u7g$1@gioia.aioe.org>
X-Mailer: Apple Mail (2.3608.120.23.2.7)
Subject: Re: [Info-ingres] Nvarchar versus UTF-8 varchar
X-BeenThere: info-ingres@lists.planetingres.org
X-Mailman-Version: 2.1.12
Precedence: list
List-Id: <info-ingres.lists.planetingres.org>
List-Unsubscribe: <https://lists.planetingres.org/mailman/options/info-ingres>, <mailto:info-ingres-request@lists.planetingres.org?subject=unsubscribe>
List-Archive: <https://lists.planetingres.org/pipermail/info-ingres/>
List-Post: <mailto:info-ingres@lists.planetingres.org>
List-Help: <mailto:info-ingres-request@lists.planetingres.org?subject=help>
List-Subscribe: <https://lists.planetingres.org/mailman/listinfo/info-ingres>, <mailto:info-ingres-request@lists.planetingres.org?subject=subscribe>
Newsgroups: comp.databases.ingres
Message-ID: <mailman.68.1627478576.1681.info-ingres@lists.planetingres.org>
Lines: 24
X-Usenet-Provider: http://www.giganews.com
X-Trace: sv3-vXBsX5Z5Z6UGWO9Z3JVrRsDyRyjqOWBbNRNVpJmbtfWjgt/McQp+CYdS+rGEE0ho+eV7BI3Wgxi1Yux!brOshdQxiFsgYoyqBZlgna+8eZjieIhw4Vfjghinci6nOUdzYta8fjJUAYx0qp/D93mRlP5fPNFz!41U+zsQ52DjISbe9AhQR4g==
X-Complaints-To: abuse@giganews.com
X-DMCA-Notifications: http://www.giganews.com/info/dmca.html
X-Abuse-and-DMCA-Info: Please be sure to forward a copy of ALL headers
X-Abuse-and-DMCA-Info: Otherwise we will be unable to process your complaint properly
X-Postfilter: 1.3.40
X-Original-Bytes: 2630
 by: Karl Schendel - Wed, 28 Jul 2021 13:22 UTC

> On Jul 28, 2021, at 9:14 AM, Roy Hann <specially@processed.almost.meat> wrote:
>
> A colleague has asked a question for which I have no answer.
>
> When II_CHARSETxx is UTF8 what is the difference between VARCHAR and
> NVARCHAR?
>
> I know NVARCHAR uses UTF-16.

Actually, I think NVARCHAR uses UCS-2, at least on the Ingres side. That's
not quite the same thing.

>
> Why might I use NVARCHAR if my data can be represented with VARCHAR?

I think the answer is probably "you wouldn't".

I do try to remain as ignorant of characters as possible, though.

Karl

Re: [Info-ingres] Nvarchar versus UTF-8 varchar

<mailman.69.1627479505.1681.info-ingres@lists.planetingres.org>

  copy mid

https://www.novabbs.com/devel/article-flat.php?id=102&group=comp.databases.ingres#102

  copy link   Newsgroups: comp.databases.ingres
Path: i2pn2.org!i2pn.org!paganini.bofh.team!news.dns-netz.com!news.freedyn.net!newsfeed.xs4all.nl!newsfeed7.news.xs4all.nl!tr2.eu1.usenetexpress.com!feeder.usenetexpress.com!tr3.iad1.usenetexpress.com!border1.nntp.dca1.giganews.com!nntp.giganews.com!buffer1.nntp.dca1.giganews.com!buffer2.nntp.dca1.giganews.com!news.giganews.com.POSTED!not-for-mail
NNTP-Posting-Date: Wed, 28 Jul 2021 08:40:03 -0500
Return-Path: <adrian.williamson@rationalcommerce.com>
X-Original-To: info-ingres@lists.planetingres.org
Delivered-To: info-ingres@mort.croker.net
From: adrian.w...@rationalcommerce.com (Adrian Williamson)
To: "'Karl Schendel'" <schendel@kbcomputer.com>, <info-ingres@lists.planetingres.org>
References: <sdrl81$u7g$1@gioia.aioe.org> <0B5AE349-5753-40C4-9601-4E77C6CAF23B@kbcomputer.com>
In-Reply-To: <0B5AE349-5753-40C4-9601-4E77C6CAF23B@kbcomputer.com>
Date: Wed, 28 Jul 2021 14:38:20 +0100
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
X-Mailer: Microsoft Outlook 16.0
Thread-Index: AQJiuplQywATDu9JN1nVznjRJMjnjgIBJ/u2qjHsjfA=
Content-Language: en-gb
X-Provags-ID: V03:K1:qQicFS0jByvqnvC2Ovt3C4VJ2wQYZ1EJPMX4SOZhTjh+nhMROdn hbOAZf3JaaYFMD7EDRCinV6AEaofGjm/0CaaqfP88iOi2PWPn3/Y/dimuC0xfi7qgq2kPEv zW5r2Y9n9UmrRiIZHjbOsnunvL/btFER2ew9lYSRWfYQ0ZwRV8Ip52e2y8ZM/p+U5EXgJ3j PndRmXNVMNEH5hdj+jU0w==
X-Spam-Flag: NO
X-UI-Out-Filterresults: notjunk:1;V03:K0:MFnkYv/YqCA=:JAUmURtVa9c80y6gsonFJq KpCXGNod2LaKbXzRSo+Q08km5Vd/BCNToDJYWB6ZobpYCntHps0EAZGgbRaYh9ElfDJvApzFW SLO8GS5WcAdsITFMEbIL4Wg/LpyIBD6z8XyDIkUpegrVzyOeVu8Nu8FhGDeWCBmiPbnBh2kx5 inBiq7B09ejLTUlGVMHO3VopYsr1y1JUbvpb2x4T8vjsg7uNLBn6gO8SKnWm9NEtcj0LFJH8H qzQ4DNclpCYYTwYN0ulQn4cbh+X9Pr2FC/OERmlE65JPzDje9EgX5iGMtsnBnhU2u0Cf4qIss MsGhots7D3uagF2R5Amotou8i8ZVZvtKaLwLeegsUD0C1/R6d1DcUPGlcW1ZoyZXameLsxPc9 nmGdbW8SqmqOvnVo1fV0rRzECDVOd/ycXoUQn0Wbf6K5a9xAq9gZEGc5gmVPv9b0EuyAGKod9 b3HNwVtghf0vxnZVNNfUT/IYZALi9XyKko02D+sdVHrPJ7KjksywMN3v20xMch1xoWJIBArYH cAWNDVoD7X6unEtk3DKCFL6hh4b/GGXKYNC8WTVgH1xlACRIZWFFX5mkjjbmn76SKAadmhzPC qgbIW1Wz8TYtsEBgcb0B93Jq8piRJq6v+5TCe73k522tTeZ9OrxP3Neo71Yoi2KxSu0SY2TPE //R/R2bqxWzGYnBZCRghKtwq5ot2StezKOicHofnAS71bToYh6Cal0fv3A/vSy4IOeH232sAg +Leqma+zqDVl70N9tNDF83J9CU6A4W+WbFoRHdLxBLOkN2Zc2MBnOh2qXhmF4GHrKg0yL0HbX B3ujHUa0PSxjkNEKEjYylr8fnNe2x84U9r6H1aBY+Sr4AeHSiABk2tI/h7XY2ZUYyOOwXTLoJ Mug4a6644LVHfBKduQzQ==
Subject: Re: [Info-ingres] Nvarchar versus UTF-8 varchar
X-BeenThere: info-ingres@lists.planetingres.org
X-Mailman-Version: 2.1.12
Precedence: list
List-Id: <info-ingres.lists.planetingres.org>
List-Unsubscribe: <https://lists.planetingres.org/mailman/options/info-ingres>, <mailto:info-ingres-request@lists.planetingres.org?subject=unsubscribe>
List-Archive: <https://lists.planetingres.org/pipermail/info-ingres/>
List-Post: <mailto:info-ingres@lists.planetingres.org>
List-Help: <mailto:info-ingres-request@lists.planetingres.org?subject=help>
List-Subscribe: <https://lists.planetingres.org/mailman/listinfo/info-ingres>, <mailto:info-ingres-request@lists.planetingres.org?subject=subscribe>
Newsgroups: comp.databases.ingres
Message-ID: <mailman.69.1627479505.1681.info-ingres@lists.planetingres.org>
Lines: 65
X-Usenet-Provider: http://www.giganews.com
X-Trace: sv3-ZEz0LIDx3qcAuqnvEYN4kG9EaUObxQYhaPPG3A8SiIYDg9INqreQi22rDcR6f8/gpI7M32Li0EGM9Wr!Sh9cRHgvwcFwWqoobfR6vF1iLyrucKNtizap5D8Y+7Ftp8jGJe9vjTiYwUkwOQ2UKlgxO2ofSk9t!Ns0AePG8+JvgMXHyS4BN9Q==
X-Complaints-To: abuse@giganews.com
X-DMCA-Notifications: http://www.giganews.com/info/dmca.html
X-Abuse-and-DMCA-Info: Please be sure to forward a copy of ALL headers
X-Abuse-and-DMCA-Info: Otherwise we will be unable to process your complaint properly
X-Postfilter: 1.3.40
X-Original-Bytes: 5851
 by: Adrian Williamson - Wed, 28 Jul 2021 13:38 UTC

Hi

I think NVARCHAR only survived a very limited number of OR versions before
technology moved on:

>From the OR manuals:

*OpenROAD transparent Unicode support negates the need for nchar and
nvarchar data types to be used in OpenROAD 4GL applications. The nchar and
nvarchar data types, introduced in OpenROAD 5.0, can be used only in a
limited number of ways. The varchar data type with UTF8 encoding is all that
is needed for Unicode support; to prevent nchar and nvarchar data types from
being used accidentally, setthe environment variable,
II_W4GL_ALLOW_NVARCHAR, to FALSE. If the variable is set to TRUE (the
default), the nchar and nvarchar data types may be declared and used in
OpenROAD 4GL applications. For more information about
II_W4GL_ALLOW_NVARCHAR, see the Workbench User Guide.
Another environment variable, II_W4GL_PASS_NVARCHAR_AS_WCHAR, if set to
TRUE, will pass any user 3GL procedure parameters of the data type nvarchar
as wide chars to the user 3GL procedure. If it is set to FALSE, nvarchars
will be coerced to chars before passing them to the user 3GL procedure. The
default is FALSE. For more information about II_W4GL_PASS_NVARCHAR_AS_WCHAR,
see the Workbench User Guide.

So I would avoid using it at all unless you are very special.

Cheers

Adrian

-----Original Message-----
From: info-ingres-bounces@lists.planetingres.org
<info-ingres-bounces@lists.planetingres.org> On Behalf Of Karl Schendel
Sent: 28 July 2021 14:23
To: info-ingres@lists.planetingres.org
Subject: Re: [Info-ingres] Nvarchar versus UTF-8 varchar

> On Jul 28, 2021, at 9:14 AM, Roy Hann <specially@processed.almost.meat>
wrote:
>
> A colleague has asked a question for which I have no answer.
>
> When II_CHARSETxx is UTF8 what is the difference between VARCHAR and
> NVARCHAR?
>
> I know NVARCHAR uses UTF-16.

Actually, I think NVARCHAR uses UCS-2, at least on the Ingres side. That's
not quite the same thing.

>
> Why might I use NVARCHAR if my data can be represented with VARCHAR?

I think the answer is probably "you wouldn't".

I do try to remain as ignorant of characters as possible, though.

Karl

_______________________________________________
Info-ingres mailing list
Info-ingres@lists.planetingres.org
https://lists.planetingres.org/mailman/listinfo/info-ingres

Re: [Info-ingres] Nvarchar versus UTF-8 varchar

<sdroqf$p35$1@gioia.aioe.org>

  copy mid

https://www.novabbs.com/devel/article-flat.php?id=103&group=comp.databases.ingres#103

  copy link   Newsgroups: comp.databases.ingres
Path: i2pn2.org!i2pn.org!aioe.org!ow2HZ3WUoSa7bUAoHqrJ8A.user.46.165.242.75.POSTED!not-for-mail
From: specia...@processed.almost.meat (Roy Hann)
Newsgroups: comp.databases.ingres
Subject: Re: [Info-ingres] Nvarchar versus UTF-8 varchar
Date: Wed, 28 Jul 2021 14:15:43 -0000 (UTC)
Organization: Aioe.org NNTP Server
Message-ID: <sdroqf$p35$1@gioia.aioe.org>
References: <sdrl81$u7g$1@gioia.aioe.org> <mailman.68.1627478576.1681.info-ingres@lists.planetingres.org>
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
Injection-Info: gioia.aioe.org; logging-data="25701"; posting-host="ow2HZ3WUoSa7bUAoHqrJ8A.user.gioia.aioe.org"; mail-complaints-to="abuse@aioe.org";
User-Agent: XPN/1.2.6 (Street Spirit ; Windows)
X-Notice: Filtered by postfilter v. 0.9.2
 by: Roy Hann - Wed, 28 Jul 2021 14:15 UTC

Karl Schendel wrote:

>> I know NVARCHAR uses UTF-16.
>
> Actually, I think NVARCHAR uses UCS-2, at least on the Ingres side. That's
> not quite the same thing.

No, it's not. I take that to mean the difference has never mattered
enough. :-)

>> Why might I use NVARCHAR if my data can be represented with VARCHAR?
>
> I think the answer is probably "you wouldn't".

Deal.

Roy

1
server_pubkey.txt

rocksolid light 0.9.8
clearnet tor