How to using BLOB by Rev2.0 & MySQL4.1

Rev rev at forest-e.co.jp
Fri Jun 27 01:05:00 EDT 2003


Hi  Tuviah,
Thank you for your suggestion.
I was waiting for it.

> When using MySQL and Rev2.0, which character set should be used?
>>I tried ucs2 which is 16bit Unicode. (because Rev2.0 was 16bit unicode)
>>It seems that however, use of ucs2 was too early also at MySQL4.1.
> 
> OK for anyone who plans to use japanese or other international characters
> with database, I would suggest you get and set everything in UTF-8. Most
> databases support UTF-8, and Rev can encode/decode UTF-8 to unicode. 


BTW,
Where is the database sample stack(without "Database Query Builder").
How to recordset by Previous & Next button on my stack.

I tried the method which I had before taught to Jan.
But, I was not able to see a picture.
Then, Rev has frozen.

> - you'll need a way to go through the records, so
> create a series of buttons (First, Prev,Next,Last)
>  + when you create the 'First' button, use the
> 'Inspector' palette and go to the 'Database' panel.
>  + use the 'Query' option menu to select the query
>  + use the 'Action' option menu to tell it to go to
> the first record
>  + ... the other buttons are similar ...
> - now you can view all the images in your table
> - you may have noticed that when you set the necessary
> information in the 'Database' panel in the 'Inspector'
> palette for your image control, there was also a
> checkbox 'Update after editing'
>  + if you check that, and make changes to the image,
> these ought to be updated back to the database

Regards,

Yujis




More information about the use-livecode mailing list