Alpha Video Training
Results 1 to 3 of 3

Thread: How to insert high order characters / special characters to MYSQL

  1. #1
    Member
    Real Name
    Joe Chasko
    Join Date
    Aug 2011
    Location
    Sacramento, California
    Posts
    43

    Default How to insert high order characters / special characters to MYSQL

    I had a tough time inserting text like "Michelin

  2. #2
    "Certified" Alphaholic mikeallenbrown's Avatar
    Real Name
    Mike Brown
    Join Date
    Nov 2009
    Location
    United States
    Posts
    1,732

    Default Re: How to insert high order characters / special characters to MYSQL

    I work almost exclusively in Microsoft SQL Server and this works ...

    Ashampoo_Snap_Sunday, April 14, 2019_12h02m36s_008_.png

    Using db-fiddle I can do the same in MySQL ...

    Ashampoo_Snap_Sunday, April 14, 2019_12h08m30s_009_.png

    Am I misunderstanding something?
    Mike Brown - Contact Me
    Programmatic Technologies, LLC
    Programmatic-Technologies.com
    Independent Developer & Consultant

  3. #3
    Member
    Real Name
    Joe Chasko
    Join Date
    Aug 2011
    Location
    Sacramento, California
    Posts
    43

    Default Re: How to insert high order characters / special characters to MYSQL

    Yes - for some reason the forum ate the high-order characters in our examples, and chopped off my example of the solution.

    We are talking about the superscript (R) in this case. The solution is to convert to UTF8 encoding. I also set the DB to UTF8.

    text = CONVERT_ACP_TO_UTF8(text) ' So MySQL takes specials


    Quote Originally Posted by mikeallenbrown View Post
    I work almost exclusively in Microsoft SQL Server and this works ...

    Ashampoo_Snap_Sunday, April 14, 2019_12h02m36s_008_.png

    Using db-fiddle I can do the same in MySQL ...

    Ashampoo_Snap_Sunday, April 14, 2019_12h08m30s_009_.png

    Am I misunderstanding something?

Similar Threads

  1. Portuguese special characters
    By cpampas in forum Mobile & Browser Applications
    Replies: 2
    Last Post: 06-17-2015, 11:09 AM
  2. Email special characters
    By info@computoria.nl in forum Application Server Version 11 - Web/Browser Applications
    Replies: 7
    Last Post: 09-02-2012, 01:39 PM
  3. special characters ü ä ï
    By Luc Verlee in forum Alpha Five Version 5
    Replies: 0
    Last Post: 01-21-2004, 12:17 PM
  4. special characters
    By martinwcole in forum Alpha Five Version 5
    Replies: 9
    Last Post: 10-04-2003, 07:26 AM
  5. Fractions - Special characters
    By kgilroy in forum Alpha Five Version 5
    Replies: 0
    Last Post: 11-19-2002, 12:29 AM

Bookmarks

Posting Permissions

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