Book a Demo

Author Topic: MySQL repository in UTF8  (Read 3031 times)

naviway

  • EA Novice
  • *
  • Posts: 4
  • Karma: +0/-0
    • View Profile
MySQL repository in UTF8
« on: February 06, 2012, 09:04:19 pm »
Dear Team,

As we are trying to have special characters in model we need UTF8 as target MySQL repository DB. But we have problem to load MySQL schema to DB. We use MyISAM Engine.

Also it is seen in DB creation script:
MySQL_MyISAM_EASchema.sql

that the tables are assumed to be created under latin1 DB.

#------------------------------------------------------------
# Enterprise Architect Schema Script
# DBMS:     MySQL MyISAM
# VERSION:  From 4.                        
# CREATED:  21/1/2010
# MODIFIED:      20/5/2010 - Removed CHARACTER SET latin1 clause.                   
# EA BUILD: 852        
#------------------------------------------------------------

What you suggest when there is need for UTF8 code page.
Previously we had latin1 code page, but we received such an error as in attachment ("incorrect string value xc4 ...").