{"action":"created","issue":{"url":"https://api.github.com/repos/Jusas/SQLite3UE4/issues/2","labels_url":"https://api.github.com/repos/Jusas/SQLite3UE4/issues/2/labels{/name}","comments_url":"https://api.github.com/repos/Jusas/SQLite3UE4/issues/2/comments","events_url":"https://api.github.com/repos/Jusas/SQLite3UE4/issues/2/events","html_url":"https://github.com/Jusas/SQLite3UE4/issues/2","id":91849511,"number":2,"title":"Question about max query lenght","user":{"login":"KhArtNJava","id":757085,"avatar_url":"https://avatars.githubusercontent.com/u/757085?v=3","gravatar_id":"","url":"https://api.github.com/users/KhArtNJava","html_url":"https://github.com/KhArtNJava","followers_url":"https://api.github.com/users/KhArtNJava/followers","following_url":"https://api.github.com/users/KhArtNJava/following{/other_user}","gists_url":"https://api.github.com/users/KhArtNJava/gists{/gist_id}","starred_url":"https://api.github.com/users/KhArtNJava/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/KhArtNJava/subscriptions","organizations_url":"https://api.github.com/users/KhArtNJava/orgs","repos_url":"https://api.github.com/users/KhArtNJava/repos","events_url":"https://api.github.com/users/KhArtNJava/events{/privacy}","received_events_url":"https://api.github.com/users/KhArtNJava/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-06-29T16:25:10Z","updated_at":"2015-06-29T16:37:34Z","closed_at":null,"body":"Hi.\r\n\r\nI found, that max possible query length for sqlite3_exec may be 127 symbols.\r\nFor example:\r\n\r\ncode:\r\n```\r\nANSICHAR* dbNameAsUtf8 = TCHAR_TO_UTF8(*Databases[DatabaseName]);\r\n\tint32 i = sqlite3_open(dbNameAsUtf8, &db);\r\n\r\n\tif (i == SQLITE_OK){\r\n\r\n\t\tANSICHAR* queryAsUtf8 = TCHAR_TO_UTF8(*query);\r\n\t\tint32 k = sqlite3_exec(db, queryAsUtf8, NULL, 0, &zErrMsg);\r\n\r\n\t\tif (i == SQLITE_OK){\r\n\t\t\tsuccess = true;\r\n\t\t}\r\n\t\telse {\r\n\t\t\tLOGSQLITE(Warning, TEXT(\"CreateTable - Query Exec Failed..\"));\r\n\t\t}\r\n```\r\nQuery with string length 127 worked well:\r\n```\r\nCREATE TABLE IF NOT EXISTS dsfsdfdfDFDFDFADSFADSFASFSDFSAFASFASFASDFSADFSDFSD777(F1 INTEGER , F2 TEXT , F3 REAL , f4 NUMERIC );\r\n```\r\nBut same query, but with 128 symbols \r\n```\r\nCREATE TABLE IF NOT EXISTS dsfsdfdfDFDFDFADSFADSFASFSDFSAFASFASFASDFSADFSDFSD777A(F1 INTEGER , F2 TEXT , F3 REAL , f4 NUMERIC );\r\n```\r\nExecutes without error, but table not created.\r\n\r\nCan you explain, how to fix this (possible bug)?"},"comment":{"url":"https://api.github.com/repos/Jusas/SQLite3UE4/issues/comments/116753667","html_url":"https://github.com/Jusas/SQLite3UE4/issues/2#issuecomment-116753667","issue_url":"https://api.github.com/repos/Jusas/SQLite3UE4/issues/2","id":116753667,"user":{"login":"KhArtNJava","id":757085,"avatar_url":"https://avatars.githubusercontent.com/u/757085?v=3","gravatar_id":"","url":"https://api.github.com/users/KhArtNJava","html_url":"https://github.com/KhArtNJava","followers_url":"https://api.github.com/users/KhArtNJava/followers","following_url":"https://api.github.com/users/KhArtNJava/following{/other_user}","gists_url":"https://api.github.com/users/KhArtNJava/gists{/gist_id}","starred_url":"https://api.github.com/users/KhArtNJava/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/KhArtNJava/subscriptions","organizations_url":"https://api.github.com/users/KhArtNJava/orgs","repos_url":"https://api.github.com/users/KhArtNJava/repos","events_url":"https://api.github.com/users/KhArtNJava/events{/privacy}","received_events_url":"https://api.github.com/users/KhArtNJava/received_events","type":"User","site_admin":false},"created_at":"2015-06-29T16:37:34Z","updated_at":"2015-06-29T16:37:34Z","body":"... And I found, that if I run \r\n```\r\nint32 k = sqlite3_exec(db, \"CREATE TABLE IF NOT EXISTS dsfsdfdfDFDFDFADSFADSFASFSDFSAFASFASFASDFSADFSDFSD777A(F1 INTEGER , F2 TEXT , F3 REAL , f4 NUMERIC );\", NULL, 0, &zErrMsg);\r\n```\r\n- it's works well - table created.\r\nMay be it's issue of the \r\n```\r\nANSICHAR* queryAsUtf8 = TCHAR_TO_UTF8(*query);\r\n```\r\nMay be ANSICHAR* queryAsUtf8 max len is 127 bytes?"}}