markthepharaoh wrote on Wednesday, February 03, 2010:
Is there a way to tell which type of database that I have? I upgraded from 3.0 to 3.1 and I don’t remember which version was running before 3.0, it might have been 2.9? Thanks.
Mark
visolveemr wrote on Friday, February 05, 2010:
If your are interested in the MySQL version, then you can get it from Admin -> Database. Could you please provide some details about your requirement?
- ViCarePlus Team
markthepharaoh wrote on Monday, February 08, 2010:
May be I misstated the question, all I want know if my data type is UTF-8 or not?
bradymiller wrote on Tuesday, February 09, 2010:
hey,
i’m guessing you have a hybrid UTF-8 and latin1 database. Can be checked in Administration->Database->(then click on openemr)->the encoding/collation of each table will be shown (either utf8_general_ci(is utf8) vs latin_swedish_ci(is latin1). If considering converting to pure utf8, see this wiki page first:
http://www.openmedsoftware.org/wiki/OpenEMR_UTF-8_Upgrade_Howto
-brady