Hi, > STRINGTOUTF8(@biodata) function returns a byte array of 3412 bytes
No it doesn't. It returns a byte array of 1706 bytes. However if you store the 1706 byte array as VARCHAR then the byte array is encoded as hex digits, which means 3412 characters (each byte two characters). As I wrote: "- use the binary data type (not varchar and not blob or clob)" > UTF16 H2 never uses UTF16. Regards, Thomas -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
