Staggan

Hello There are currently 5 databases.... I thought MySQL used to allow a restore that was additive... as in would append records to existing tables, if those tables existed... Ideally I want something that I can just name dbase 1 as source and dbase 2 as destination.... and add dbase 3 to that result...

Hello I have multiple copies of a database schema, all with separate data... I now want to merge all of this data into one location... I have prepared all the individual databases so there is no clash of any unique ID's etc... but I cannot find anything that will allow me to append the data from one database to the other... For example.. I have a table called user and another called purchases... this table exists in each database... But now I want to merge that data into a single place... I know I can do it table by table, but that is slow and if anything goes wrong it could take a long time to resolve... Are there any automated tools I can use ? Thanks

Originally It is was to do with server loading and regional latency, but we have introduced new systems to mitigate this to the point now where managing multiple user databases has become time consuming and problematic... My question is more about the implications of multiple connections to a MySQL database access the same tables at the same time... So, if I have one user table in a database and multiple connections to that database that act on that user table, what are the implications?

Hello I am looking for information on allowing multiple instances of our application to access the same database... Currently we have each instance(generally a geographic region) of our application having its own database but this is proving problematic to manage... but if a user decides to install the application for another region all their user data is non existent in that region, so a new account must be created.. Ideally we would like to have a single user database for ALL instances (regions).... Is there any specific I need to do or consider to allow this? Thanks

I have tried the above suggestion... This is what I do... function validateString($string) { $character_validation_pattern = '/\\A[\\x{00C0}-\\x{01FF}\\x{0600}-\\x{06FF}]+\\z/u'; if (preg_match($character_validation_pattern, $string)){ return true; } return false; }

Can you clarify how this works for me? As I do not understand it... Thanks

I appreciate your help, sorry, maybe I got a little confused with the answer... Let me explain a little more, perhaps it will help... Our app reads the latest news on login and displays it to the user, this news could be in a multitude of languages. We limit the characters for each language so that we can handle so many in a single app, a windows app, without ever needing to use windows font systems as they have a number of additional limitations. So, to put the news into the database we use a PHP page, but occasionally the person responsible for the news in a particular language manages to use a character we do not support.. which causes an issue.... Our app uses the ranges above which are the unicode numerical representation of the characters we allow...at least in Windows. I thought PHP might allow me a similar way to make the comparison, but it seems there is nothing quite that simple... As for your last point.. I see it, and can only assume it is an oversight somehow.. I will point it out... Thanks

I have rechecked with our coders, and we actually compare characters with their unicode value to ensure they are within the ranges I specified in my first post.. So, how can I confirm that each character falls within one of those ranges in my first post?

The unicode solution sounds possible.. Can you provide me some more information on that? Thanks

We support several languages within our application and our font system has limitations. Those limitations include omitting some valid but less used characters to allow us to support so many languages in the way we do... BTW, this is not a web application, but the text is added via a web page...

I thought I should explain a little more.. Our text is saved as UTF-8 into the database but several characters when imported to our application cause issues, the ellipsis being one of them, hence we check each character is within a specific range when imported. So, my question is still how do I get the hex value of a character in PHP... The rest is simple. Thanks

I can't just get the hex code of each character? Or is this because the code changes depending on the encoding?

Hello I have a PHP page that sends text entered by a user to our database which we use to display news. This system supports various languages but occasionally we get issues with odd characters being entered... For example, the premade glyph for ellipsis which is normally represented by 3 .'s broke our system today How can I check that each character is valid and within range? These are our character ranges ExtendedLatin_c_iLowerAlphaChar = 0x00C0; ExtendedLatin_c_iUpperAlphaChar = 0x01FF; Arabic_c_iLowerChar = 0x600; Arabic_c_iUpperChar = 0x6FF; Arabic_c_iLowerAlphaChar = 0x621; Arabic_c_iUpperAlphaChar = 0x64A; Arabic_c_iLowerNumericChar = 0x660; Arabic_c_iUpperNumericChar = 0x669; So each character must fall within one of these ranges... but I have no idea how to get the hex value of a character in PHP Thanks

Doh! Thanks, wood for trees comes to mind..

Doh! I have changed it to just encode the url now... but still the same error...