Regular expression and special charactere

[Nicolas]

What is the proper syntax for matching any special character like "Ú é à"
etc...
This is the string source:
SELECT DocUNID, [Name] AS 'Dép./Prov.', StateCode AS 'Code', name_en AS
'English', name_fr AS 'Français', name_es AS 'Español', name_it AS
'Italiano', name_pt AS 'Português', name_de AS 'Deutsch' FROM StateCity WHERE
ApplyTo='S' AND CountryCode='CA' ORDER BY 'Dép./Prov.'

This is the RegExp pattern:
(.* FROM )(?<TABLE>[\'\[\]\.\/-zA-Z_]*)(.* ORDER BY
)(?<ORDERBY>[\'\[\]\.\/-zA-Z_]*)


Return:
Match
SELECT DocUNID, [Name] AS 'Dép./Prov.', StateCode AS 'Code', name_en AS
'English', name_fr AS 'Français', name_es AS 'Español', name_it AS
'Italiano', name_pt AS 'Português', name_de AS 'Deutsch' FROM StateCity WHERE
ApplyTo='S' AND CountryCode='CA' ORDER BY 'D

$1=StateCity

$2='D

If I did put this "é" in my regExp Pattern then it works. but I don't know
wich special charactere I will have?
(.* FROM )(?<TABLE>[\'\[\]\.\/-zA-Z_]*)(.* ORDER BY
)(?<ORDERBY>[\'\[\]\.\/-zA-Z_é]*)

Thanks

 

[Nicolas]

Oops I fixed it.

(.* FROM )(?<TABLE>[\w'./\[\]]*)(.* ORDER BY )(?<ORDERBY>[\w'./\[\]]*)