How do I write flattened to string data to a MySQL database

[rsscan]

I have a cluster that I flatten to a string (length flattened string = 100 KB). I defined a column in MySQL, type longtext. I am not able to write the flattened string info into this column. It seems that the flattened to string data contains invalid chars, because I tried to write a string of 100000 'a''s to the database and it worked fine. Does someone can help me out with this.

[wiebe@CARYA]

Hi,

If the line of data contains e.g. a hex representation of a quote, zero, or
dubble quote you can expect trouble. The fastest solution would be to
convert each byte to a hexadecimal string of that byte; so in a string set
to code display "a\00bc" would become "61006263" (also in code display).

The disadvantage is that this doubles the size of the data.

Another option would be to dig deep into the ActiveX tools to send data to
ODBC, and find a way to pass data as a variant. But variant are also large.
The stored data will be small, but the data transfere will not.

Regards,

Wiebe.


"rsscan" wrote in message
news:5065000000080000007B7D0000-1042324653000@exchange.ni.com...
> I have a cluster that I flatten to a string (length flattened string
=
> 100 KB). I defined a column in MySQL, type longtext. I am not able to
> write the flattened string info into this column. It seems that the
> flattened to string data contains invalid chars, because I tried to
> write a string of 100000 'a''s to the database and it worked fine.
> Does someone can help me out with this.