O$ - 6.0 - Unicode $insert error.

[Andrew Stolarz]

Doug / Bas,

Thank you for your input.

It appears to be an issue with the MySQL DAM.


Downloading the latest MySQL DAMS from the ODPP area of the TL site appears
to solve the issue, will run more tests. According to the release notes,
this update addresses many unicode issues.



Andrew







On 12 March 2015 at 17:39, Bastiaan Olij <bastiaan at basenlily.me> wrote:

> 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
>
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com
>