Skip to main content
P
ProgmanMX
Participating Frequently
April 15, 2006
Question

Store Japan Characters by CF in MySQL DB

  • April 15, 2006
  • 1 reply
  • 543 views
Please advise How can i Store Japan Characters into MySQL database correcty ?

PhP saves Those data perfectly , but ColdFusion not .. why ?
    This topic has been closed for replies.

    1 reply

    N
    Newsgroup_User
    Inspiring
    April 15, 2006
    ProgmanMX wrote:
    > Please advise How can i make it correcty ?

    set the encoding for the db & cf application to be the same, you don't mention
    what encoding you're using.

    for that DSN add the following to the advanced connection string parameters:

    using useUnicode=true&characterEncoding=xxxxxx

    where xxxxxx is the encoding you're using.

    P
    ProgmanMXAuthor
    Participating Frequently
    April 15, 2006
    Please let me know :

    1. How can i find my current MySQL encoding ?
    2. Parameters "useUnicode=true&characterEncoding=xxxxxx" are setting in CF Admin part ?
    3. How to set up correct encodung for mySQL (I have accessible just control Panel+PhPMy Admin) ?
    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices