SPD Server will inherit the locale and encoding of the connecting Base SAS session, so setting it using an options statement would work in most cases. In my mid, most sites would have this in the central config file, to avoid unwanted differences between tables created by different users/processes.
You might need to recreate all tables within the cluster to be sure that they all share the same encoding.
Data never sleeps