From: Gerard Samuel <php-db@trini0.org>
To: pgsql-php@postgresql.org
Subject: Space requirements (with respect to foriegn languages)
Date: Thu, 26 Aug 2004 16:36:25 -0400
Message-ID: <412E49C9.8050609@trini0.org> (raw)
My site/code/database is developed primarily for the english language.
I've had people from "The Far East" add content to my site using their
native language, and it is displaying properly in the site.
But Im a bit concerned about the number of characters these languages use.
For example, I've had someone enter ->
chinese testing 中文
It is saved in the database as ->
chinese testing 中文
Now, forgive my ignorance, but I have no idea what the additional
chinese characters mean, but from the values in the database, Im
assuming that it amounts to 3 characters.
But if Im correct that those are 3 characters, it is
using up 24 characters in a column.
My concern is that what if I were to limit a column to say 25 "english"
characters, and a chinese fellow, comes by and hypothetically says
"Hello World" in chinese and goes over the limit of the column, the data
will be truncated.
Is there anything that can be done to overcome this shortcoming?
Im currently using PostgreSQL 7.4.2, using SQL_ASCII as the database
characterset, FreeBSD 4.10, php 4.3.6.
Thanks for any advise you can provide...
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-php@postgresql.org
Cc: php-db@trini0.org
Subject: Re: Space requirements (with respect to foriegn languages)
In-Reply-To: <412E49C9.8050609@trini0.org>
References: <412E49C9.8050609@trini0.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox