Re: WE8ISO8859P1 and UTF8
Date: Mon, 18 Aug 2008 12:38:11 +0100
When start having the ability to store characters that are stored in multiple bytes and say you have a definition of a column with for example varchar2(10) previoiusly you could store 10 characters guaranteed.
You no longer have that guarantee with the multi-byte characterset. While your application is convinced you have sent the database only 10 characters the database may reject the data as being too wide for the column if the data contains the multi-byte characters.
I have seen this behaviour numerous times.
When we went from single-byte to multi-byte we have just changed the columns affected on an ad-hoc basis as needed.
The other option is to make the application count bytes to ensure the data fired at the database is going to fit.
-- http://jarneil.wordpress.com On Mon, Aug 18, 2008 at 12:26 PM, John Dunn <JDunn_at_sefas.com> wrote:Received on Mon Aug 18 2008 - 06:38:11 CDT
> What are the differences between these 2 database character sets?
> Any reason why an application tested on WE8ISO8859P1 should not work with
> UTF8, given that no double byte characters are used?
> John Dunn
> Product Consultant
> Sefas Innovation Limited
> Direct Dial + 44 (0) 117 373 6122
> Sefas Innovation Ltd, CityPoint, Temple Gate, Bristol BS1 6PL, UK. Tel: +44
> (0) 117 373 6114 Fax: +44 (0) 117 373 6115
> *Sefas Innovation Limited. *Registered No: 3769761 England. Registered
> Office: One New Street, Wells, Somerset, BA5 2LA, United Kingdom. VAT
> Registration No: GB 741 5377 32
> Unless stated to be non-confidential, this email and any attachments are
> private and confidential and are for the addressee only. Sefas monitors
> e-mails to ensure its systems operate effectively and to minimize the risk
> of viruses. Whilst Sefas has taken reasonable steps to scan this email, it
> does not accept liability for any virus that may be contained in it.
> Internet communications are not 100% secure and as such Sefas is not
> responsible for their abuse by 3rd parties, nor for any alteration or
> corruption in transmission.