dcsimg
Results 1 to 9 of 9

Thread: Cannot save character on mysql database

Threaded View

  1. #1

    Thread Starter
    Frenzied Member
    Join Date
    May 2013
    Posts
    1,126

    Cannot save character on mysql database

    On my server all charset and collation is set to utf8 and utf8_unicode_ci.
    On my database, tables and fields is also set to utf8 and utf8_unicode_ci.
    My connection charset is also utf8.

    When I insert and update a record using NOT stored procedure code from the server like

    rs.addnew
    rs.fields("field1")=text1.text,
    rs.update

    or

    cmd.execute "action query"

    then the inserting or updating of record with special character like is properly saved or update.
    BUT when I use stored procedure THRU VB6 to insert or update a record with special character like , then that special character like is not inserted or updated along with the other characters. But when I execute the stored procedure in the server to insert or update character, then it can be save or updated.

    So what am I missing here ?

    .
    Last edited by codesearcher; May 28th, 2016 at 02:15 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Featured


Click Here to Expand Forum to Full Width