dbTalk Databases Forums  

snapshot from WE8MSWIN1252 to UTF8 database

comp.databases.oracle.misc comp.databases.oracle.misc


Discuss snapshot from WE8MSWIN1252 to UTF8 database in the comp.databases.oracle.misc forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Imran Rahim
 
Posts: n/a

Default snapshot from WE8MSWIN1252 to UTF8 database - 07-23-2003 , 08:45 AM






We are trying to snapshot data from 8.1.7.4 database with single byte
8bit characterset (WE8MSWIN1252) to multipbyte (UTF8) also running
8.1.7.4

However we have realised that any field sizes are multipled by 3 to
accomodate any characters that will require 3 bytes to be stored in
their equivalent form on a multi-byte character set database e.g. Euro
character

This creates a problem with large keys because they are hitting the
limit of 3218 bytes available for the PK in a 8k block size.

Is there any way of preventing this multiplication of the field sizes
?

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.