Hello. I have an problem with collation in MySQL database and somewhere with my Apache Server Settings. I have a simple popup window that should display all cities that begins with Prefix entered. It’s ok if a city name doesn’t have non-english letters. This is what I get:
Server Error
Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.
………
Apache/2.0.43 Server at localhost Port 80
In my Apache Error Log
[error] [client 127.0.0.1] (22)Invalid argument: couldn't spawn child process: C:/PHP/php.exe
It happens when I try to filter records with non-english character sets like
Öhringen
Jülich
Bechynë….
In database, I have varchar column for cities names with
Collation = Latin1_swedish_ci
And my Apache language settings they are:
# Danish (da) - Dutch (nl) - English (en) - Estonian (et)
# French (fr) - German (de) - Greek-Modern (el)
# Italian (it) - Norwegian (no) - Norwegian Nynorsk (nn) - Korean (ko)
# Portugese (pt) - Luxembourgeois* (ltz)
# Spanish (es) - Swedish (sv) - Catalan (ca) - Czech(cz)
# Polish (pl) - Brazilian Portuguese (pt-br) - Japanese (ja)
# Russian (ru) - Croatian (hr)
#
AddLanguage da .dk
AddLanguage nl .nl
AddLanguage en .en
AddLanguage et .et
AddLanguage fr .fr
AddLanguage de .de
AddLanguage he .he
AddLanguage el .el
AddLanguage it .it
AddLanguage ja .ja
AddLanguage pl .po
AddLanguage ko .ko
AddLanguage pt .pt
AddLanguage nn .nn
AddLanguage no .no
AddLanguage pt-br .pt-br
AddLanguage ltz .ltz
AddLanguage ca .ca
AddLanguage es .es
AddLanguage sv .se
AddLanguage cz .cz
AddLanguage ru .ru
AddLanguage tw .tw
AddLanguage zh-tw .tw
AddLanguage hr .hr
It seems to me that this is an MySQL and Apache problem.
What can be a problem and is there a solution for this? Thanks for any suggestions.
Server Error
Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.
………
Apache/2.0.43 Server at localhost Port 80
In my Apache Error Log
[error] [client 127.0.0.1] (22)Invalid argument: couldn't spawn child process: C:/PHP/php.exe
It happens when I try to filter records with non-english character sets like
Öhringen
Jülich
Bechynë….
In database, I have varchar column for cities names with
Collation = Latin1_swedish_ci
And my Apache language settings they are:
# Danish (da) - Dutch (nl) - English (en) - Estonian (et)
# French (fr) - German (de) - Greek-Modern (el)
# Italian (it) - Norwegian (no) - Norwegian Nynorsk (nn) - Korean (ko)
# Portugese (pt) - Luxembourgeois* (ltz)
# Spanish (es) - Swedish (sv) - Catalan (ca) - Czech(cz)
# Polish (pl) - Brazilian Portuguese (pt-br) - Japanese (ja)
# Russian (ru) - Croatian (hr)
#
AddLanguage da .dk
AddLanguage nl .nl
AddLanguage en .en
AddLanguage et .et
AddLanguage fr .fr
AddLanguage de .de
AddLanguage he .he
AddLanguage el .el
AddLanguage it .it
AddLanguage ja .ja
AddLanguage pl .po
AddLanguage ko .ko
AddLanguage pt .pt
AddLanguage nn .nn
AddLanguage no .no
AddLanguage pt-br .pt-br
AddLanguage ltz .ltz
AddLanguage ca .ca
AddLanguage es .es
AddLanguage sv .se
AddLanguage cz .cz
AddLanguage ru .ru
AddLanguage tw .tw
AddLanguage zh-tw .tw
AddLanguage hr .hr
It seems to me that this is an MySQL and Apache problem.
What can be a problem and is there a solution for this? Thanks for any suggestions.