# SQL Statement Strings in eXtremeSQL

> There is no simple limit on the length of SQL statements in eXtremeSQL. It depends on the API or tool being used.

> When using the C API functions `mcosql_execute_statement()` or `mcosql_execute_query()` or the C++ class SqlEngine methods `executeStatement()` or `executeQuery()`, the statement of query string length is unlimited. The same applies to the corresponding statement and query execution methods in the JNI, Python and C# wrappers.

> However, when using the eXtremeSQL interpreter `SqlEngine::main()` or xSQL (which uses this method internally), the maximum size of an SQL statement is limited to 64 Kb.

> Also when using remote SQL, the statement size is limited by the size of the transmit buffer, which is specified in the C++ RemoteSqlEngine constructor (the default value is 64 Kb). This 64 Kb default is also present in the Java, Python and C# wrappers for remote SQL connections and for the SqlAggregator class.