O$ - 6.0 - Unicode $insert error.

[Bastiaan Olij]

Hi Andrew,

It might be a problem with the DAM thinking it is more then 255
characters then.
... test – 2 acre ...

Your –, if I read your original email correctly, is one of the upper
unicode characters representing by 2 characters internally. So it takes
up 2 bytes, not one, making the total size of your string 256 bytes.

It may be that the DAM is counting bytes while MySQL itself counts
"real" character instead of bytes.

Cheers,

Bas

On 13/03/2015 2:54 am, Andrew Stolarz wrote:
> Hi Bas,
>
>
> Thank you for your response, however I’m not too sure we are talking about
> the same “issue” here. Below is a sample full string of text (255
> characters in length)…less the quotes.
>
> “This is a test – 2 acre this is a test this is a test this is a test this
> is a test this is a test this is a test this is a test this is a test this
> is a test this is a test this is a test this is a test this is a test this
> is a test this is a test this i”
>
>
> When I try to use this string of text and manually run a SQL update
> directly from within MySQL Workbench, I do not have any issues and I am
> able to insert the data without any problems.
>
> When I try to use the same string of text and allow Omnis to insert it into
> the MySQL database using the $insert()  command as mentioned previously, I
> get the error.
>
>
> Why does this work outside of Omnis, but not with Omnis?
>
>
> Andrew