| NCLOB_CONVERSION [message #454434] |
Wed, 05 May 2010 10:02  |
mike15
Messages: 16
Registered: May 2010
|
Junior Member |
|
|
|
Does anyone have have a routine that does conversion for data stored in NLCOB (UTF16) to BLOB type.
|
|
|
|
|
|
|
|
| Re: NCLOB_CONVERSION [message #454445 is a reply to message #454434] |
Wed, 05 May 2010 10:55  |
mike15
Messages: 16
Registered: May 2010
|
Junior Member |
|
|
I tried CONVERTTOBLOB procedure but i got a characer set error mismatch error because NCLOB was UTF-16 and BLOB was ISO88591 (db character set).
I want to download a file using mod_plsql and it only supports BLOB files. I want to store the data in NCLOB to get the unicode format and then convert to binary which would be representation of unciode instead of iso88591.
|
|
|
|
|
|
| Re: NCLOB_CONVERSION [message #454457 is a reply to message #454446] |
Wed, 05 May 2010 12:03 |
mike15
Messages: 16
Registered: May 2010
|
Junior Member |
|
|
yes, but I beleive Binary representation for a single-byte encoding (ISO8859) is different than Binary representation for multi-byte encoding scheme (UTF-16). If you have one character represented by 2 bytes in UTF-16 it will have a binary set for each byte while the ISO8859 will have one set.
I see what you are saying about creating a file. The problem is that the server is behind a firewall and teh file would not be accessible. They are also blocking mounts to a server outside firewall. So i want a table solution where it is stored/downloade from a table via mod_pslql. i am using WPG_DOCLOAD to download the file and it only supports BLOB.
|
|
|
|
|
|
| Re: NCLOB_CONVERSION [message #454459 is a reply to message #454457] |
Wed, 05 May 2010 12:12 |
 |
Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
Quote:yes, but I beleive Binary representation for a single-byte encoding (ISO8859) is different than Binary representation for multi-byte encoding scheme (UTF-16).
Yes but this is irrelevant to the fact that BLOB are strictly binary data and doesn't if what you stored is string, image, video, music and so on. Will you say that music in BLOB is in ISO8859 code? This is meaningless.
I move the topic in "Application Express & MOD_PLSQL" forum you have a better chance to get an answer in this forum.
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
