v12.6      OS 10.6.8

Hello!
I was recently made aware of the fact that, on some web pages, a multiplication 
sign was displaying as what looked like a square root symbol + a lowercase 
accented "o".

The database is running in unicode; the web site is using UTF-8. The pages in 
question are displaying a blob variable that contains about 4000 line items. 
The blob was created using the constant UTF8 text without length.

The only clue I found was a brief note under PROCESS HTML TAGS: "Beginning with 
version 12 of 4D, when you use BLOB type parameters, the command automatically 
considers that the character set used for BLOBs is MacRoman."

I didn't see that important detail mentioned anywhere but in reference to that 
one command, but, since text variables can now hold up to 2 GB, I tried 
substituting a text variable.

Doing that did clear up the multiplication sign issue, but now the data was 
truncated. Only about 3000 line items were displayed.

Would 4000 line items be enough to overflow 2 GB? (Each line item contains only 
around 300 characters.)

I can split the data into two text variables, and that appears to work, but it 
seems like it should be unnecessary.

What are some recommended ways to handle this?

Thank you all in advance -
Janie


Janie Marlow
[email protected]
Travelers Rest, SC
**********************************************************************
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:[email protected]
**********************************************************************

Reply via email to