Our company is trying to convert our Lasso based website (8.6) so that it
can display Chinese and foreign characters correctly.

We've converted our lasso pages from Latin1 to UTF-8 encoding with BOM.

We've also converted our MySQL data sources to UTF-8 unicode encoding.
We're running MySQL version 5.6.17

--------------------------------
Here's a couple of scenarios and the results:

Case 1: Access Chinese characters from a MySQL table with a PHP page
Result: displays correctly

Case 2: Display Chinese characters that are first stored in a lasso
variable on a Lasso page
Result: displays correctly

Case 3: Access Chinese characters stored in a MySQL table with a Lasso page
with the option -table
Result: displays correctly

[var: 'Search_SQL'='SELECT * FROM Test_Table WHERE
`Record_ID` = \'204261\' OR `Record_ID` = \'19567\'' + ';']

[inline: -Table='Test_Table', -SQL = $Search_SQL, -MaxRecords=3,
-Database='CC']

Case 4: Access Chinese character from a MySQL table with a Lasso page
WITHOUT -table option
Result: does not display correctly. Shows ??????? instead

[var: 'Search_SQL'='SELECT * FROM Test_Table WHERE
`Record_ID` = \'204261\' OR `Record_ID` = \'19567\'' + ';']

[inline: -SQL = $Search_SQL, -MaxRecords=3, -Database='CC']
--------------------------------
What I suspect is that adding the -Table option forces it to go through
Lasso engine where-as leaving off -Table maybe contacts the MySQL engine
directly???

Not only would I prefer not having to add the -Table option but I also feel
like I could gain a better understanding of how Lasso is working under the
hood by being able to perform this action without the -Table option.
Could I ask for your help as far as what I can do to get the data as UTF-8
even without the -Table option being used?

#############################################################

This message is sent to you because you are subscribed to
the mailing list Lasso Lasso@lists.lassosoft.com
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <Lasso-unsubscribe@lists.lassosoft.com>
Send administrative queries to <Lasso-request@lists.lassosoft.com>