LiveCode Forums.

the mb4 says that it uses up to four bytes for a character and if I try to set my collation to utf8_general_ci my database won't allow that as that is deprecated. It was the same as utf8mb3 if I remember correctly, and that used up to three bytes for a character which is not how utf8 works anymore. ...

Thanks for the reply! The encoding of the SQL database has to match what encoding you are using with textEncode before storing in the database. Yes, but according to that document, utf8mb4_general_ci is using the charset utf8mb4, thus my (obviously faulty!) idea was to do a textEncode(myStr, "uff-8"...

Is there any possibility in this universe to insert non-ascii data correctly into a field in a MySQL database? If I have a table mytable in "myDB" with a field "content" The field is set to utf8mb4_general_ci and try the following code: put revOpenDatabase("mysql", "localhost","MyDB", "myUser", "myp...

B: I use it on a webserver at our university. At the moment there are mainly small utilities for getting account credentials, getting results, etc. But in the near future, I will probably use it to build more tools that integrate several of our other systems. I usually create a tool in the LiveCode ...

Thanks for your continuing effort. But to be clear: I can't create a new database as I for that get HTTP/1.1 401 Unauthorized, I can't delete a database. For that I also get HTTP/1.1 401 Unauthorized. Everything else works! I have no strange characters in the username / password (even tried with tes...

This also work: PUT empty into url "http://127.0.0.1:5984/plankton" Thanks for all input but the problem is that all of your code above works for me too as long as I have not closed down the database with username and password. When I close it down, the put empty … above will give me an error, even...

Hi! Trying to do some basic operations with CouchDB via it's REST interface. Running curl from the command line works perfectly but trying from LiveCode is currently only partially working. I guess it's me but if someone could share some light I would be really grateful! Example 1 I would like to cr...

No, bad way! Your way have very bad side effects in a multi user enviroment. You load the database of commands, and it waits a commit... The Transaction idea is to compact command in a unique command, this way you risk too much uncompleted tasks, overloading or database and so on... Try to limit as...

Not all databases support the revCommitDatabase command. The command is currently supported by Oracle, PostgreSQL and SQLite databases only. Calling the revCommitDatabase command on any other type of database connection will have no affect. I know that but it still doesn't tell me what it does when...

Well that's how I usually do it also, but as there is a revCommitDatabase I thought that someone could explain what it actually does... Hmm, there is a difference between your solution and my ordinary solution. And that is that I call revExecuteSQL for each item otherwise I can't secure the input. S...

Can someone explain how revCommitDatabase works? As far as I can see there is no way to start the transaction. And according to another post here revCommitDatabase saves all changes since the last revCommitDatabase. But if that is true, should I then call revCommitDatabase do all my inserts, updates...

Looking at the JavaScript console I see that every time when the request fails I see that I get :

Failed to load resource: The request timed out.

I have similar experience across supported browsers.

Thanks! I'm sure that I tried that first but tried again now and it somewhat works. I have a card with two fields: URL, Result and a button with the following code: on mouseUp put field "URL" into tURL put url tURL into tData if the result is empty then put tData into field "Result" else put the res...

Have anyone succeeded to use get URL?

If I put my LiveCode project files on a server at
http://www.example.com/test/

and then try to get a file via:
I get an assertion failure. Anyone having tried the get url command with a successful result?

This might be a nice add to the HTML deployment. But if the engine allows for modularisation I guess that is in plan for future releases. Another way to improve the download speed is to have a fast CDN from where the files are downloaded. If everyone downloaded the engine .js and .mem files from the...