Dictionary To JSON to store in MySQL DB.

General
1

I’m a bit lost when it comes strings vs text…

I’d like to take a dictionary and convert it to json so I can store it in a database.
but I get lost in the the conversion from string to text as it seems the new xojo frameworks that have json methods want text.
Help?

2

I just do something like this in the new framework:

Dim theJSON As Text = GenerateJSON(theDictionary)
3

[quote=357619:@Jason Tait]I just do something like this in the new framework:

Dim theJSON As Text = GenerateJSON(theDictionary) [/quote]
But how do you take the Text and convert it to a string?

4 
Dim s As String = theJSON.ToCString(Xojo.Core.TextEncoding.UTF8)
5

Actually, just assign it. Nothing special is needed from text to string.

6

dim t as text = “abcd”
dim s as string = t