I build pico-56 microcomputer. It has 2 ports for NES joystick. I have several joystick with db9 and broken wires/connectors, and decide to repair with NES 7pin connector. Light googling show me pinouts and now joysticks works.

I note this here.

ps. joystick with db9 - modern schematic for unification with rs232 devices. Original wiring use db7

DB9 nes joystick pinout

Connector

9 8 7 6 5
 4 3 2 1

Signals with colors

1 n/c   | 
2 gnd   | yellow
3 n/c   | 
4 5v    | red
5 n/c   |
6 clock | brown
7 latch | blue
8 data  | white
9 n/c   |

DB7 nes joystick pinout

Connector

1
2 5
3 6
4 7

Signals with colors

1 gnd   | yellow
2 clock | brown
3 latch | blue
4 data  | white
5 5v    | red
6 n/c   | 
7 n/c   |