Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
10west
Starting Member
2 Posts |
 Posted - 2010-06-15 : 23:21:56
|
| I'm pulling data from a mysql table to a recordset to a datagrid.the data is a multi-line text description field, of type text (multi-line), and it is always returning corrupted text like (box characters) to my grid cell (where I need to see it), everything else is fine:I tested sending it to a msgbox, and it returns this sample:"????????????›???"( a bunch of question marks)except larger length of course. The original data is text field in a mysql db, and getting encoded enroute to a recordset read into a datagrid. Any knowledge on why this is happening or solutions?Another clue is that in a web page, it reads as asian characters, this is not the issue though, it reads as box characters in a vb datagrid, or MSHFlexgrid, and THATS WHERE I NEED TO READ IT IN ENGLISH, why is the grid cell showing it encoded improperly, while everything else reads english correctly (albeit, single line field data)Thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
|
|
box characters instead of readable text